You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
BULLA VERNICOSA |
4.00 | |
TELESCOPIUM TELESCOPIUM |
8.00 | |
CYMATIUM PFEIFFERIANUM |
8.00 | |
MORUM TERAMACHII |
12.00 | |
PHENACOVOLVA RECURVA |
25.00 | |
CYMATIUM PILEARE |
8.00 | |
MARGOVULA PYRIFORMIS |
6.00 | |
CALOCOCHLIA PULCHERRIMA |
4.00 | |
ERRONEA ERRONES NIGER |
50.00 | |
HYDATINA ALBOCINCTA |
8.00 | |
MUREXIELLA PELEPILI |
20.00 | |
CONUS STRIATUS |
8.00 | |
GRANATA SULCIFERA |
3.00 | |
CYPRAEA TIGRIS |
30.00 | |
PTERYNOTUS PELLUCIDUS |
10.00 | |
HYOTISSA HYOTIS |
25.00 | |
TUTUFA TENUIGRANOSA |
30.00 | |
HOMALOCANTHA ZAMBOI |
6.00 | |
MUREXIELLA PELEPILI |
6.00 | |
PHENACOVOLVA ROSEA |
6.00 | |
ZONARIA ZONARIA |
8.00 | |
COSTELLARIA UNIFASCIATA |
6.00 | |
TURBO HETEROCHEILUS |
5.00 | |
EUCITHARA ARENIVAGA |
4.00 | |
HYDATINA PHYSIS |
8.00 | |
Total: | 308.00 |